﻿CREATE TABLE [dbo].[Purord] (
    [Purno]    INT  NOT NULL,
    [Pno]      INT  NULL,
    [Gno]      INT  NULL,
    [Purprice] REAL NULL,
    [Purnum]   INT  NULL,
    PRIMARY KEY CLUSTERED ([Purno] ASC),
    FOREIGN KEY ([Pno]) REFERENCES [dbo].[Provider] ([Pno]) ON DELETE CASCADE,
    FOREIGN KEY ([Gno]) REFERENCES [dbo].[Goods] ([Gno]) ON DELETE CASCADE
);

